#!/usr/bin/env pythonBasics
# -*-coding:utf-8-*-

#Author:super

import mysql.connector

mydb = mysql.connector.connect(
	host = 'localhost',
	port = '3309',
	user = 'root',
	password = 'root',
	database = 'runoob_db'
)

mycursor = mydb.cursor()

mycursor.execute('create table sites (name varchar(255),url varchar(255))')
mycursor.execute("ALTER TABLE sites ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY")


mycursor.close()